<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" /><title>JDBCUtils xref</title>
<link type="text/css" rel="stylesheet" href="../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../../../../../../../apidocs/org/sakaiproject/genericdao/util/JDBCUtils.html">View Javadoc</a></div><pre>

<a name="1" href="#1">1</a>   <em>/**<em>*</em></em>
<a name="2" href="#2">2</a>   <em> * $Id: JDBCUtils.html 11 2009-01-29 14:58:33Z azeckoski $</em>
<a name="3" href="#3">3</a>   <em> * $URL: http://genericdao.googlecode.com/svn/maven/site/xref/org/sakaiproject/genericdao/util/JDBCUtils.html $</em>
<a name="4" href="#4">4</a>   <em> * JDBCUtils.java - genericdao - Aug 4, 2008 6:12:37 PM - azeckoski</em>
<a name="5" href="#5">5</a>   <em> **************************************************************************</em>
<a name="6" href="#6">6</a>   <em> * Copyright (c) 2008 Aaron Zeckoski</em>
<a name="7" href="#7">7</a>   <em> * Licensed under the Apache License, Version 2.0</em>
<a name="8" href="#8">8</a>   <em> * </em>
<a name="9" href="#9">9</a>   <em> * A copy of the Apache License has been included in this </em>
<a name="10" href="#10">10</a>  <em> * distribution and is available at: <a href="http://www.apache.org/licenses/LICENSE-2.0.txt" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0.txt</a></em>
<a name="11" href="#11">11</a>  <em> *</em>
<a name="12" href="#12">12</a>  <em> * Aaron Zeckoski (azeckoski @ gmail.com) (aaronz @ vt.edu) (aaron @ caret.cam.ac.uk)</em>
<a name="13" href="#13">13</a>  <em> */</em>
<a name="14" href="#14">14</a>  
<a name="15" href="#15">15</a>  <strong>package</strong> org.sakaiproject.genericdao.util;
<a name="16" href="#16">16</a>  
<a name="17" href="#17">17</a>  <strong>import</strong> java.util.ArrayList;
<a name="18" href="#18">18</a>  <strong>import</strong> java.util.List;
<a name="19" href="#19">19</a>  
<a name="20" href="#20">20</a>  <strong>import</strong> org.azeckoski.reflectutils.ConversionUtils;
<a name="21" href="#21">21</a>  <strong>import</strong> org.sakaiproject.genericdao.api.mappers.NamesRecord;
<a name="22" href="#22">22</a>  <strong>import</strong> org.sakaiproject.genericdao.api.search.Restriction;
<a name="23" href="#23">23</a>  <strong>import</strong> org.sakaiproject.genericdao.api.search.Search;
<a name="24" href="#24">24</a>  
<a name="25" href="#25">25</a>  
<a name="26" href="#26">26</a>  <em>/**<em>*</em></em>
<a name="27" href="#27">27</a>  <em> * A set of utilities to help working with JDBC</em>
<a name="28" href="#28">28</a>  <em> * </em>
<a name="29" href="#29">29</a>  <em> * @author Aaron Zeckoski (azeckoski @ gmail.com)</em>
<a name="30" href="#30">30</a>  <em> */</em>
<a name="31" href="#31">31</a>  <strong>public</strong> <strong>class</strong> <a href="../../../../org/sakaiproject/genericdao/util/JDBCUtils.html">JDBCUtils</a> {
<a name="32" href="#32">32</a>  
<a name="33" href="#33">33</a>      <em>/**<em>*</em></em>
<a name="34" href="#34">34</a>  <em>     * Make a partial SQL string for a specific entity type using the associated {@link NamesRecord}</em>
<a name="35" href="#35">35</a>  <em>     * and a {@link Search} object</em>
<a name="36" href="#36">36</a>  <em>     * @param namesRecord a record of the mapping of property to columns for an entity type</em>
<a name="37" href="#37">37</a>  <em>     * @param search a search object</em>
<a name="38" href="#38">38</a>  <em>     * @return an object with the partial where SQL query and the params (args)</em>
<a name="39" href="#39">39</a>  <em>     */</em>
<a name="40" href="#40">40</a>      <strong>public</strong> <strong>static</strong> QueryData makeSQLfromSearch(<a href="../../../../org/sakaiproject/genericdao/api/mappers/NamesRecord.html">NamesRecord</a> namesRecord, <a href="../../../../org/sakaiproject/genericdao/api/search/Search.html">Search</a> search) {
<a name="41" href="#41">41</a>          <em class="comment">// Checks to see if the required params are set and throws exception if not</em>
<a name="42" href="#42">42</a>          <strong>if</strong> (search == <strong>null</strong>) {
<a name="43" href="#43">43</a>              <strong>throw</strong> <strong>new</strong> IllegalArgumentException(<span class="string">"search cannot be null"</span>);
<a name="44" href="#44">44</a>          }
<a name="45" href="#45">45</a>  
<a name="46" href="#46">46</a>          QueryData sd = <strong>new</strong> QueryData();
<a name="47" href="#47">47</a>          <em class="comment">//NamesRecord nr = getNamesRecord(type);</em>
<a name="48" href="#48">48</a>          StringBuilder sql = <strong>new</strong> StringBuilder();
<a name="49" href="#49">49</a>  
<a name="50" href="#50">50</a>          <em class="comment">// Only add in restrictions if there are some to add</em>
<a name="51" href="#51">51</a>          <strong>if</strong> (search.getRestrictions() != <strong>null</strong> &amp;&amp; search.getRestrictions().length > 0) {
<a name="52" href="#52">52</a>              <em class="comment">// set up the conjunction</em>
<a name="53" href="#53">53</a>              String junction = <span class="string">" and "</span>;
<a name="54" href="#54">54</a>              <strong>if</strong> (! search.conjunction) {
<a name="55" href="#55">55</a>                  <em class="comment">// set to use disjunction</em>
<a name="56" href="#56">56</a>                  junction = <span class="string">" or "</span>;
<a name="57" href="#57">57</a>              }
<a name="58" href="#58">58</a>  
<a name="59" href="#59">59</a>              <em class="comment">// put in the restrictions</em>
<a name="60" href="#60">60</a>              <strong>for</strong> (<strong>int</strong> i = 0; i &lt; search.getRestrictions().length; i++) {
<a name="61" href="#61">61</a>                  <strong>if</strong> (i > 0) {
<a name="62" href="#62">62</a>                      sql.append(junction);
<a name="63" href="#63">63</a>                  }
<a name="64" href="#64">64</a>                  String property = search.getRestrictions()[i].property;
<a name="65" href="#65">65</a>                  Object value = search.getRestrictions()[i].value;
<a name="66" href="#66">66</a>                  <strong>if</strong> (property == <strong>null</strong> || value == <strong>null</strong>) {
<a name="67" href="#67">67</a>                      <strong>throw</strong> <strong>new</strong> IllegalArgumentException(<span class="string">"restrictions property and value cannot be null or empty"</span>);            
<a name="68" href="#68">68</a>                  }
<a name="69" href="#69">69</a>  
<a name="70" href="#70">70</a>                  String column = namesRecord.getColumnForProperty(property);
<a name="71" href="#71">71</a>                  <em class="comment">// we cannot recover from the case where the property is invalid</em>
<a name="72" href="#72">72</a>                  <strong>if</strong> (column == <strong>null</strong>) {
<a name="73" href="#73">73</a>                  	<strong>throw</strong> <strong>new</strong> IllegalArgumentException(<span class="string">"Cannot find a column which matches the property ("</span>+property+<span class="string">") for search: "</span> + search);
<a name="74" href="#74">74</a>                  }
<a name="75" href="#75">75</a>                  <strong>if</strong> (value.getClass().isArray()) {
<a name="76" href="#76">76</a>                      <em class="comment">// special handling for "in" type comparisons</em>
<a name="77" href="#77">77</a>                      Object[] objectArray = (Object[]) value;
<a name="78" href="#78">78</a>                      <strong>if</strong> (objectArray.length == 1) {
<a name="79" href="#79">79</a>                          value = objectArray[0];
<a name="80" href="#80">80</a>                      } <strong>else</strong> <strong>if</strong> (objectArray.length > 1) {
<a name="81" href="#81">81</a>                          sql.append(column);
<a name="82" href="#82">82</a>                          <strong>if</strong> (Restriction.NOT_EQUALS == search.getRestrictions()[i].comparison) {
<a name="83" href="#83">83</a>                              sql.append(<span class="string">" not in "</span>);
<a name="84" href="#84">84</a>                          } <strong>else</strong> {
<a name="85" href="#85">85</a>                              sql.append(<span class="string">" in "</span>);
<a name="86" href="#86">86</a>                          }
<a name="87" href="#87">87</a>                          <em class="comment">// need to create this kind of thing: (?,?,?) where there are 3 things in the array</em>
<a name="88" href="#88">88</a>                          sql.append(<span class="string">"("</span>);
<a name="89" href="#89">89</a>                          <strong>for</strong> (<strong>int</strong> j = 0; j &lt; objectArray.length; j++) {
<a name="90" href="#90">90</a>                              <strong>if</strong> (j > 0) { sql.append(','); }
<a name="91" href="#91">91</a>                              sql.append('?');
<a name="92" href="#92">92</a>                          }
<a name="93" href="#93">93</a>                          sql.append(<span class="string">") "</span>);
<a name="94" href="#94">94</a>                          <em class="comment">// now we need to add the array of values (and convert possibly all of them)</em>
<a name="95" href="#95">95</a>                          <strong>for</strong> (<strong>int</strong> j = 0; j &lt; objectArray.length; j++) {
<a name="96" href="#96">96</a>                              sd.addArg( convertColumn(namesRecord, column, objectArray[j]) );
<a name="97" href="#97">97</a>                          }
<a name="98" href="#98">98</a>                          <em class="comment">//sd.addArrayArg(objectArray);</em>
<a name="99" href="#99">99</a>                      } <strong>else</strong> {
<a name="100" href="#100">100</a>                         <em class="comment">// do nothing for now, this is slightly invalid but not worth dying over</em>
<a name="101" href="#101">101</a>                     }
<a name="102" href="#102">102</a>                 }
<a name="103" href="#103">103</a> 
<a name="104" href="#104">104</a>                 <strong>if</strong> (! value.getClass().isArray()) {
<a name="105" href="#105">105</a>                     <strong>int</strong> comparisonConstant = search.getRestrictions()[i].comparison;
<a name="106" href="#106">106</a>                     <em class="comment">// convert if needed</em>
<a name="107" href="#107">107</a>                     value = convertColumn(namesRecord, column, value);
<a name="108" href="#108">108</a>                     sql.append( makeComparisonSQL(sd.args, namesRecord.getColumnForProperty(property), comparisonConstant, value) );
<a name="109" href="#109">109</a>                 }
<a name="110" href="#110">110</a>             }
<a name="111" href="#111">111</a>         }
<a name="112" href="#112">112</a> 
<a name="113" href="#113">113</a>         <em class="comment">// handle the sorting (sort param can be null for no sort)</em>
<a name="114" href="#114">114</a>         <strong>if</strong> (search.getOrders() != <strong>null</strong>) {
<a name="115" href="#115">115</a>             StringBuilder orderSQL = <strong>new</strong> StringBuilder();
<a name="116" href="#116">116</a>             <strong>if</strong> (search.getOrders().length > 0) {
<a name="117" href="#117">117</a>                 orderSQL.append(<span class="string">" order by "</span>);
<a name="118" href="#118">118</a>                 <strong>for</strong> (<strong>int</strong> i = 0; i &lt; search.getOrders().length; i++) {
<a name="119" href="#119">119</a>                     <strong>if</strong> (i > 0) {
<a name="120" href="#120">120</a>                         orderSQL.append(<span class="string">", "</span>);
<a name="121" href="#121">121</a>                     }
<a name="122" href="#122">122</a>                     String property = search.getOrders()[i].property;
<a name="123" href="#123">123</a>                     orderSQL.append(namesRecord.getColumnForProperty(property));
<a name="124" href="#124">124</a>                     <strong>if</strong> (search.getOrders()[i].ascending) {
<a name="125" href="#125">125</a>                         orderSQL.append(<span class="string">" asc "</span>);
<a name="126" href="#126">126</a>                     } <strong>else</strong> {
<a name="127" href="#127">127</a>                         orderSQL.append(<span class="string">" desc "</span>);
<a name="128" href="#128">128</a>                     }
<a name="129" href="#129">129</a>                 }
<a name="130" href="#130">130</a>             }
<a name="131" href="#131">131</a>             sd.orderSQL = orderSQL.toString();
<a name="132" href="#132">132</a>         }
<a name="133" href="#133">133</a> 
<a name="134" href="#134">134</a>         sd.whereSQL = sql.toString();
<a name="135" href="#135">135</a>         <strong>return</strong> sd;
<a name="136" href="#136">136</a>     }
<a name="137" href="#137">137</a> 
<a name="138" href="#138">138</a>     <em>/**<em>*</em></em>
<a name="139" href="#139">139</a> <em>     * Create comparison SQL but converts the value object to a string</em>
<a name="140" href="#140">140</a> <em>     * </em>
<a name="141" href="#141">141</a> <em>     * @param column the name of a database column</em>
<a name="142" href="#142">142</a> <em>     * @param comparisonConstant the comparison constant (e.g. EQUALS)</em>
<a name="143" href="#143">143</a> <em>     * @param value the value to compare the property to</em>
<a name="144" href="#144">144</a> <em>     * @return a string representing the SQL snippet (e.g. propA = ?)</em>
<a name="145" href="#145">145</a> <em>     */</em>
<a name="146" href="#146">146</a>     <strong>public</strong> <strong>static</strong> String makeComparisonSQL(String column, <strong>int</strong> comparisonConstant, Object value) {
<a name="147" href="#147">147</a>         String sval = <strong>null</strong>;
<a name="148" href="#148">148</a>         <strong>if</strong> (comparisonConstant != Restriction.NOT_NULL 
<a name="149" href="#149">149</a>                 &amp;&amp; comparisonConstant != Restriction.NULL) {
<a name="150" href="#150">150</a>             <strong>if</strong> (value.getClass().isAssignableFrom(Boolean.<strong>class</strong>) 
<a name="151" href="#151">151</a>                     || value.getClass().isAssignableFrom(Number.<strong>class</strong>)) {
<a name="152" href="#152">152</a>                 <em class="comment">// special handling for boolean and numbers</em>
<a name="153" href="#153">153</a>                 sval = value.toString();
<a name="154" href="#154">154</a>             } <strong>else</strong> {
<a name="155" href="#155">155</a>                 sval = <span class="string">"'"</span> + value.toString() + <span class="string">"'"</span>;
<a name="156" href="#156">156</a>             }
<a name="157" href="#157">157</a>         }
<a name="158" href="#158">158</a>         <strong>return</strong> buildComparisonSQL(column, comparisonConstant, sval);
<a name="159" href="#159">159</a>     }
<a name="160" href="#160">160</a> 
<a name="161" href="#161">161</a>     <em>/**<em>*</em></em>
<a name="162" href="#162">162</a> <em>     * Create comparison SQL but places the values into the params list</em>
<a name="163" href="#163">163</a> <em>     * </em>
<a name="164" href="#164">164</a> <em>     * @param params a set of params to add this value to</em>
<a name="165" href="#165">165</a> <em>     * @param column the name of a database column</em>
<a name="166" href="#166">166</a> <em>     * @param comparisonConstant the comparison constant (e.g. EQUALS)</em>
<a name="167" href="#167">167</a> <em>     * @param value the value to compare the property to</em>
<a name="168" href="#168">168</a> <em>     * @return a string representing the SQL snippet (e.g. propA = ?)</em>
<a name="169" href="#169">169</a> <em>     */</em>
<a name="170" href="#170">170</a>     <strong>public</strong> <strong>static</strong> String makeComparisonSQL(List&lt;Object> params, String column, <strong>int</strong> comparisonConstant, Object value) {
<a name="171" href="#171">171</a>         <strong>if</strong> (comparisonConstant != Restriction.NOT_NULL 
<a name="172" href="#172">172</a>                 &amp;&amp; comparisonConstant != Restriction.NULL) {
<a name="173" href="#173">173</a>             params.add(value);
<a name="174" href="#174">174</a>         }
<a name="175" href="#175">175</a>         <strong>return</strong> buildComparisonSQL(column, comparisonConstant, <span class="string">"?"</span>);
<a name="176" href="#176">176</a>     }
<a name="177" href="#177">177</a> 
<a name="178" href="#178">178</a>     <em>/**<em>*</em></em>
<a name="179" href="#179">179</a> <em>     * Convenient way to translate constants into SQL,</em>
<a name="180" href="#180">180</a> <em>     * sVal can be any string value including ?</em>
<a name="181" href="#181">181</a> <em>     */</em>
<a name="182" href="#182">182</a>     <strong>protected</strong> <strong>static</strong> String buildComparisonSQL(String column, <strong>int</strong> comparisonConstant, String sval) {
<a name="183" href="#183">183</a>         <strong>switch</strong> (comparisonConstant) {
<a name="184" href="#184">184</a>         <strong>case</strong> Restriction.EQUALS:      <strong>return</strong> column + <span class="string">" = "</span> + sval;
<a name="185" href="#185">185</a>         <strong>case</strong> Restriction.GREATER:     <strong>return</strong> column + <span class="string">" > "</span> + sval;
<a name="186" href="#186">186</a>         <strong>case</strong> Restriction.LESS:        <strong>return</strong> column + <span class="string">" &lt; "</span> + sval;
<a name="187" href="#187">187</a>         <strong>case</strong> Restriction.LIKE:        <strong>return</strong> column + <span class="string">" like "</span> + sval;
<a name="188" href="#188">188</a>         <strong>case</strong> Restriction.NOT_EQUALS:  <strong>return</strong> column + <span class="string">" &lt;> "</span> + sval;
<a name="189" href="#189">189</a>         <strong>case</strong> Restriction.NOT_NULL:    <strong>return</strong> column + <span class="string">" is not null"</span>;
<a name="190" href="#190">190</a>         <strong>case</strong> Restriction.NULL:        <strong>return</strong> column + <span class="string">" is null"</span>;
<a name="191" href="#191">191</a>         <strong>default</strong>: <strong>throw</strong> <strong>new</strong> IllegalArgumentException(<span class="string">"Invalid comparison constant: "</span> + comparisonConstant);
<a name="192" href="#192">192</a>         }
<a name="193" href="#193">193</a>     }
<a name="194" href="#194">194</a> 
<a name="195" href="#195">195</a>     <em>/**<em>*</em></em>
<a name="196" href="#196">196</a> <em>     * This helper method will convert the incoming data if it needs to be</em>
<a name="197" href="#197">197</a> <em>     * converted for the given column, otherwise it will do nothing to the value</em>
<a name="198" href="#198">198</a> <em>     * @param namesRecord the names record for the persistent class</em>
<a name="199" href="#199">199</a> <em>     * @param column the name of the column this value is associated with</em>
<a name="200" href="#200">200</a> <em>     * @param value the value to convert</em>
<a name="201" href="#201">201</a> <em>     * @return the converted value or the original value if no conversion needed</em>
<a name="202" href="#202">202</a> <em>     */</em>
<a name="203" href="#203">203</a>     <strong>public</strong> <strong>static</strong> Object convertColumn(<a href="../../../../org/sakaiproject/genericdao/api/mappers/NamesRecord.html">NamesRecord</a> namesRecord, String column, Object value) {
<a name="204" href="#204">204</a>         <strong>if</strong> (namesRecord != <strong>null</strong> &amp;&amp; column != <strong>null</strong>) {
<a name="205" href="#205">205</a>             <strong>try</strong> {
<a name="206" href="#206">206</a>                 Class&lt;?> convertType = namesRecord.getTypeForColumn(column);
<a name="207" href="#207">207</a>                 <strong>if</strong> (convertType != <strong>null</strong>) {
<a name="208" href="#208">208</a>                     value = ConversionUtils.getInstance().convert(value, convertType);
<a name="209" href="#209">209</a>                 }
<a name="210" href="#210">210</a>             } <strong>catch</strong> (Exception e) {
<a name="211" href="#211">211</a>                 <em class="comment">// nothing to do but continue on</em>
<a name="212" href="#212">212</a>             }
<a name="213" href="#213">213</a>         }
<a name="214" href="#214">214</a>         <strong>return</strong> value;
<a name="215" href="#215">215</a>     }
<a name="216" href="#216">216</a> 
<a name="217" href="#217">217</a> 
<a name="218" href="#218">218</a> 
<a name="219" href="#219">219</a>     <em>/**<em>*</em></em>
<a name="220" href="#220">220</a> <em>     * Special class for passing SQL query data for running queries with,</em>
<a name="221" href="#221">221</a> <em>     * has methods to get the where statement and the set of params (args)</em>
<a name="222" href="#222">222</a> <em>     * </em>
<a name="223" href="#223">223</a> <em>     * @author Aaron Zeckoski (azeckoski@gmail.com)</em>
<a name="224" href="#224">224</a> <em>     */</em>
<a name="225" href="#225">225</a>     <strong>public</strong> <strong>static</strong> <strong>class</strong> QueryData {
<a name="226" href="#226">226</a>         <strong>public</strong> String whereSQL = <span class="string">""</span>;
<a name="227" href="#227">227</a>         <strong>public</strong> String orderSQL = <span class="string">""</span>;
<a name="228" href="#228">228</a>         <strong>public</strong> List&lt;Object> args = <strong>new</strong> ArrayList&lt;Object>();
<a name="229" href="#229">229</a>         <em>/**<em>*</em></em>
<a name="230" href="#230">230</a> <em>         * Add an argument value to the arg array</em>
<a name="231" href="#231">231</a> <em>         * @param value an object</em>
<a name="232" href="#232">232</a> <em>         */</em>
<a name="233" href="#233">233</a>         <strong>public</strong> <strong>void</strong> addArg(Object value) {
<a name="234" href="#234">234</a>             args.add(value);
<a name="235" href="#235">235</a>         }
<a name="236" href="#236">236</a>         <em>/**<em>* </em></em>
<a name="237" href="#237">237</a> <em>         * Add an array of argument values to the arg array</em>
<a name="238" href="#238">238</a> <em>         * @param values an array of objects</em>
<a name="239" href="#239">239</a> <em>         */</em>
<a name="240" href="#240">240</a>         <strong>public</strong> <strong>void</strong> addArrayArg(Object[] values) {
<a name="241" href="#241">241</a>             <strong>for</strong> (<strong>int</strong> i = 0; i &lt; values.length; i++) {
<a name="242" href="#242">242</a>                 addArg(values[i]);
<a name="243" href="#243">243</a>             }
<a name="244" href="#244">244</a>         }
<a name="245" href="#245">245</a>         <em>/**<em>*</em></em>
<a name="246" href="#246">246</a> <em>         * Get the SQL statement to place after the tables in the SQL statement,</em>
<a name="247" href="#247">247</a> <em>         * typically this is something like "where name like '%aaronz%' order by name"</em>
<a name="248" href="#248">248</a> <em>         * @return the string to place after the table list, will not be null</em>
<a name="249" href="#249">249</a> <em>         */</em>
<a name="250" href="#250">250</a>         <strong>public</strong> String getAfterTableSQL() {
<a name="251" href="#251">251</a>             String sql = <span class="string">""</span>;
<a name="252" href="#252">252</a>             <strong>if</strong> (whereSQL != <strong>null</strong> &amp;&amp;  !(<span class="string">""</span>.equals(whereSQL))) {
<a name="253" href="#253">253</a>                 sql = <span class="string">" where "</span> + whereSQL;
<a name="254" href="#254">254</a>             }
<a name="255" href="#255">255</a>             <strong>if</strong> (orderSQL != <strong>null</strong> &amp;&amp;  !(<span class="string">""</span>.equals(orderSQL))) {
<a name="256" href="#256">256</a>                 sql += orderSQL;
<a name="257" href="#257">257</a>             }
<a name="258" href="#258">258</a>             <strong>return</strong> sql;
<a name="259" href="#259">259</a>         }
<a name="260" href="#260">260</a>         <em>/**<em>*</em></em>
<a name="261" href="#261">261</a> <em>         * @return the array of arguments which should replace the ? is the sql string</em>
<a name="262" href="#262">262</a> <em>         */</em>
<a name="263" href="#263">263</a>         <strong>public</strong> Object[] getArgs() {
<a name="264" href="#264">264</a>             <strong>return</strong> args.toArray();
<a name="265" href="#265">265</a>         }
<a name="266" href="#266">266</a>     }
<a name="267" href="#267">267</a> 
<a name="268" href="#268">268</a> }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

